Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rkpatelqlikview
Creator III
Creator III

Multiple records with in one cell

Hi All, Hope you doing great.


How to find out/ separate   and count the multiple records with in one cell in same field.

Attached the example

Thanks in advance

KUMAR

1 Solution

Accepted Solutions
kenphamvn
Creator III
Creator III

Hi

Try This

[Sheet1]:

LOAD [Trip Id],

[Vehicle Number],

SubField([Do Number],'|') as Separate_Do_Number,

substringcount( [Do Number] , '|') +1 as Numberofrecord,

    [Carrier Name],

[Carrier Code]

FROM [lib://Downloads/Sample1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards

An Pham

View solution in original post

3 Replies
kenphamvn
Creator III
Creator III

Hi

Try This

[Sheet1]:

LOAD [Trip Id],

[Vehicle Number],

SubField([Do Number],'|') as Separate_Do_Number,

substringcount( [Do Number] , '|') +1 as Numberofrecord,

    [Carrier Name],

[Carrier Code]

FROM [lib://Downloads/Sample1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards

An Pham

techvarun
Specialist II
Specialist II

Use SubstringCount function

For Example:  SubStringCount([Do Number],'|')+1

rkpatelqlikview
Creator III
Creator III
Author

Yes. correct one.

Thanks for your support.