Reading 80 millions records in qlikview

[#1]

Hi,

We have to read 80 million records in qlikview which will be present in a csv in the below form

User Name	Channel Name
Neha Jain	Social
Neha Jain	Email
Neha Jain	Social
Neha Jain	Conversion
Neha Jain	Social
Neha Jain	Display Ad
Neha Jain	Conversion
Ankit  Jain	Email
Ankit  Jain	Social
Ankit  Jain	Conversion

Based on above table , we need to show a path report like this in qlikview

User Name	Path
Neha Jain	Social-> Email-> Social-> Conversion -> Social -> Display Ad-> Conversion
Ankit Jain	Email -> Social

Questions-

will qlikview will be able to read such huge data directly from csv or is there any better approach for these type requests

regards

Anubhav

[Clever_Anjos · Accepted solution]

Create a graph Straight Table

put User Name as Dimension

put Concat(distinct [Channel Name], '->') as expression

this should work

[MindaugasBacius]

Take a look to concat function:

Concat - script function ‒ QlikView

[Anil_Babu_Samineni]

Might be Qlik can read. But, I am not sure that

[#5]

If we like to concat depending on user name only? then

[Clever_Anjos]

not sure if I´ve understand what you written

[Anil_Babu_Samineni]

As per Clever, It is working fine for me.

If you want to show same thing just use without Distinct

Concat([Channel Name], ' -> ')