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)
Discussion Board for collaboration related to QlikView App Development.
I want to merge columns in the load script from my Excel Source.
The table looks like this:
I want to merge the Monday/Tuesday/Wednesday notes columns into a New column named notes:
How can I do this?
You can also try,
[Monday Notes] & [Tuesday Notes] & [Wednesday Notes] as Notes,
If the columns have any spaces, you can use trim function like below.
Trim([Monday Notes] & [Tuesday Notes] & [Wednesday Notes]) as Notes
View solution in original post
alt( [Monday Notes],[Tuesday Notes],[Wednesday Notes]) as Notes,
Data: CrossTable(Day,Notes,2) LOAD Date, Hours, [Monday notes], [Tuesday notes], [Wednesday notes] FROM [https://community.qlik.com/thread/218440] (html, codepage is 1252, embedded labels, table is @1); Final: NoConcatenate LOAD * Resident Data Where len(trim(Notes))<>0; DROP Table Data;
I like this method but with a slight modification:
RangeMaxString([Monday Notes], [Tuesday Notes], [Wednesday Notes]) as Notes,
trick acchi he..