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
