New value in a field representing all values

sujayrpatil — Wed, 07 Oct 2020 06:44:13 GMT

Hi,

I have data set similar to the below table. I am plotting a bar chart to Customers vs City.

City	count of Customers
A	20
B	30
C	40
D	50

The requirement is to get one more value in City column something like 'ALL' which will be combining all cities and will show total customers. I need this addition of new value to happen in Load script as I have other transformations to run after this change.

Expected Result:

City	count of Customers
A	20
B	30
C	40
D	50
All	140

Thanks In advance for your replies.

Regards,

Sujay.

Re: New value in a field representing all values

avinashelite — Wed, 07 Oct 2020 07:02:49 GMT

If you have limited values try like this

LOAD * Inline

[

City,City_Updated

A,ALL

B,ALL

C,ALL

D,ALL

A,A

B,B

C,C

D,D

];

and use the City_updates column in the front end

topic Re: New value in a field representing all values in App Development

New value in a field representing all values

Re: New value in a field representing all values