Accessing CSV

Milind — Fri, 26 Aug 2022 10:38:25 GMT

I have developed an app which reads data from .CSV file.

1) I have created main data set via load editor.

2) Joining this main table with data fetched from .CSV into temp table by Left Join to main table.

3) Joining columns are correct and values are matching but issue is

at first time its doesn't fetch matched records but when I Edit (dummy edit) the .csv file and save, then onwards my app stars reading this file correctly.

I tried with

1) Importing table into Data manager

2) Automatically editing file , but not worked

Temp table

NoConcatenate
rc_temp:
Load distinct
text(attribute) as attr_id,
text(system) as source_system,
text(system_id) as system_id,
text(le_entity_id) as branch_id,
text(Recurring) as Recurring
FROM [lib://Content (user)/parent folder/folder/file_$(vMonth).csv] (txt,utf8, embedded labels, delimiter is ',',msq)
where text(curMonth) = 'Y';

Above data is then joined as 'left join' in Data load editor

Please support in above issue.

Thank you

topic Accessing CSV in App Development

Accessing CSV