Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following table in Qlikview.
Account AccountName ProductName
050250 Tennisan Apples
050250 Tennisan Oranges
059300 Geoarges Apples
But I only want Tennisan to show up once with Oranges, Apples as the ProductName. Is this possible?
Like this:-
Account AccountName ProductName
050250 Tennisan Apples, Oranges
059300 Geoarges Apples
Cheers,
LC
I think you missed the Group By statement.
Entitlements:
LOAD.....
Group By Account, AccountNumber;
Select .....
How did you decide that the Account should be 050250 not 50250?
whoops. typo. ive updated
Use Account and AccountName as dimensions and as expression Concat(Distinct ProductName).
I guess it is a typo... I would do something like this:
LOAD Account,
AccountName,
Concat(ProductName) as ProductName
FROM .....
Group By Account, AccountName;
Table:
Load AccountName
,ProductName
,Text(Account) as Account
Inline [
Account, AccountName, ProductName
50250, Tennisan, Apples
050250, Tennisan, Oranges
059300, Geoarges, Apples
];
QUALIFY *;
tmb:
LOAD AccountName
,Concat(ProductName, ',') as ProductName
Resident Table
Group By AccountName
;
UNQUALIFY *;
The result:
Hi Sunny,
I've added Concat(ProductName) as ProductName to my script.
I'm getting the following error when uploading the attached:-
OLEDB read failed
I think you missed the Group By statement.
Entitlements:
LOAD.....
Group By Account, AccountNumber;
Select .....
Thanks Sunny