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.
Hello everybody, I am facing the following problem:
I load this table:
In this table i have text fields per ordernumber
so the data set could be like this:
ordernumber 10 / "t_seqe" = 1 / Text = "Hello"
ordernumber 10 / "t_seqe" = 2 / Text = "World"
There could be one ordernumber with different sequenze numbers and the Text should be concatenated.
Sometimes i also have a sequenze number 3 or 4 aswell.
What I need at the end is this data set is:
ordernumber 10 / Text = "Hello World"
I hope anybody can help me with this.
Hi you can use concat function
concat(Text,' ',t_seqe) as Text_Converted
resident <your table> group by ordernumber;
what's your expected result?
Hello, the original data set is like this:
ordernumber 10 / "t_seqe" = 3 / Text = "!"
and my expected result is like this:
ordernumber 10 / Text = "Hello World!"
field "t_seqe" (sequenze number) tells you into how many parts the text had been divided.
field value varries from 1 up to 5
I think what raajaswin said above should works for you.
Great. It works. Thanks a lot.
You could do it in a preceding load like:
Concat(Text, ' ', t_seqe) as CombinedText
Group By ordernumber;