Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

i have row filled with values in tfileinputdelimited . Help me converting to a specified format as below

 

 

Actually , my reqt is the count can be dynamic , say if count is 5  , then there should be 5 ids in a row.

The input column can have thousands of Ids.

 (content in tfileinputdelimited.)

1

2

3

4

5

6

7

8

9

10

 

should be as

1,2,3,4,5

6,7,8,9,10

Labels (2)
13 Replies
Anonymous
Not applicable
Author

@fdenis what is the modulo of the line index-1 ?

TRF
Champion II
Champion II

The idea of @fdenis is a good one.

Here is a new version.


rahin.zip
Anonymous
Not applicable
Author

TRF,

 

Fantastic . Thanks for my urgent help. May i know fdenis proposed solution is ?

fdenis
Master
Master

modulo the integer part of the division:
6 mod 3 --> 2
8 mod 3 --> 2
10 mod 3 --> 3

so with tMap add one integer variable named var1 (center Part)
set it as Numeric.sequnce("s1",1,1)
on the output add id column type integer set value as :Var.var1 mod 5
then add your tdenormalize on the data column.