This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Question
How do I parse a JSON string from column to flattened structure in Incorta?
Answer
Assuming a Incorta table has a column with JSON string then here is a sample pyspark code which you can use to create a Materialized view in Incorta -
from...
Supporting user’s default currency based on location and doing currency conversion
Define a internal session variable called MyCountry:
query(_IncortaMetadata.USER.COUNTRY,
_IncortaMetadata.USER.LOGINNAME = $user,
_IncortaMetadata.USER.TE...
1) First see if the EBS connection is working or not
2) Then open that schema table in Incorta, go to dataset and open the query and try to execute it and see if you see rows .
If you do not see CSV as a valid output then edit the BIP report and click "View List" in the far right. Then in the screen shown navigate to output formats (these are the allowed output formats) - click on csv and save. After this, schedule shows th...
We do not have a connector to Enovia , they are two things we can do in the meantime - 1) If they have rest APIs then you can call the API via MV and pull data via that, check article [community.incorta.com].2) See if they allow data extracts to csv ...
Here is Anurag's video that shows how to calculate max date from a table column and default that to a date prompt in the dashboard: https://youtu.be/9CdKnTh2CiM