Multiple records with in one cell

[rkpatelqlikview]

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

[kenphamvn · Accepted solution]

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]

Use SubstringCount function

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

[rkpatelqlikview]

Yes. correct one.

Thanks for your support.