This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am loading several files using a for loop and want to concatenate them (all fields in the files are the same).
I would like to add a column which shows which file the data has come from.
I have managed to get a column which displays the file names, however now I am having a problem concatenating them.
Please help! Copy of my code so far below. Many thanks.
Let vTableCount = NoOfRows('OracleTableList');
For i = 0 To $(vTableCount) -1
LET vMyTableName = Peek('OWNER', $(i), 'OracleTableList') & '.' & Peek('TABLE_NAME', $(i), 'OracleTableList');
LET vFileName = Peek('TABLE_NAME', $(i), 'OracleTableList');
SQL SELECT * FROM $(vMyTableName);
'$(vFileName)' as FileName
drop table TEMP_KPI_CUSTOMER_COMBINED;