Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i am using csv file for my report below file is for Jan month, every month we will get csv files and we have to upend the new file to existing code and we have to maintain historic data as well ... so in below case if i load file next month it will override the data of current month... so which one i have to use to uppend the data either Resident or Concatinate can you please help
Janstats:
LOAD
"Session ID",
"Session Started",
"Session Finished",
Result,
"Result Content",
"Today",
"User Name",,
FROM [lib://AttachedFiles/Jan Stats.csv]
Neither. You can just load both files, since Qlik automatically concatenates two tables if they have the exact same list of fields. If you'd like to spell it out, you can use Concatenate Load, though.
Hi,
Using an asterisk (*) in your path in place of the file name will load all available CSV files at once into one table.
Allstats:
LOAD * FROM [lib://AttachedFiles/*.csv];
i cont use( *) there are duplicate column names in CSV file so i have just taken the columns which i required for my report.
so can i write script like below? so how this will work can you please elaborate i am new to qliksense
Janstats:
LOAD
"Session ID",
"Session Started",
"Session Finished",
Result,
"Result Content",
"Today",
"User Name",,
FROM [lib://AttachedFiles/Jan Stats.csv]
Concatenate
Load
"Session ID",
"Session Started",
"Session Finished",
Result,
"Result Content",
"Today",
"User Name",,
FROM [lib://AttachedFiles/Jan Stats.csv]
I wasn't referring to the load statement, I was talking about using (*) in the directory. Assuming, column names and format remains the same.
AllStats:
LOAD
"Session ID",
"Session Started",
"Session Finished",
Result,
"Result Content",
"Today",
"User Name"
FROM [lib://AttachedFiles/*.csv];