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 have a data set that looks like this stored in big query.
I would like to load it so that it looks like this (all IDs are made into primary keys, and objects are concatenated):
1 A, B, C
2 A, D
I've tried using Group By, Aggregate, String_Agg, and Concat but none of them are working.
May be try this
[objects]:Load ID,Concat([Object], ', ') AS ObjectGROUP BY ID;SELECT ID, ObjectFROM `db.objects`;
View solution in original post
LOAD ID, Concat(Object, ', ') as ObjectFrom....Group By ID;
I get this error:
You did add the source where you are loading from, right?
Lol, how would I know what you are doing wrong if you won't even share all the details :). Please share the logfile or the script?