topic Re: Need to combine two values from a field to a single value in the same field in App Development

Need to combine two values from a field to a single value in the same field

abc_18 — Mon, 31 Oct 2022 15:57:55 GMT

Hi,

I have a field say column with values as:

Column:

my requirement is to add two values together and make it as a single value in same column like below:

B+C as ' new name'

C+D as 'new name1'

please let me know how to achieve this.

Re: Need to combine two values from a field to a single value in the same field

Mark_Little — Mon, 31 Oct 2022 16:01:11 GMT

Hi,

Your not far from it already.

LOAD

B&C as ' new name',

C&D as 'new name1',

From ...

If they are numbers then you can use the + to sum them instead of the &.

Re: Need to combine two values from a field to a single value in the same field

vinieme12 — Tue, 01 Nov 2022 02:48:54 GMT

best to Rangesum() to avoid issues with sum'ing null values

Column:

LOAD

,Rangesum(B,C) as newfield1

,Rangesum(C,D) as newfield2

From SomeDataSource;

Re: Need to combine two values from a field to a single value in the same field

abc_18 — Tue, 01 Nov 2022 08:10:16 GMT

Hello everyone, thanks for the response.

I tried above but it's not working. may be the explanation was not clear.

Actually have a compliance column in a table and need to add two values from compliance column to show the count .

load

Compliance,

OS,

OS Type

from xyz;

in that Compliance column have these 6 values as A,B,C,D,E,F and need to show the combined count of B&C and E&F in a bar chart.

I know how to combine two diff fields but my question is how to combine a field values to make one value and show the count in bar chart like below.

Re: Need to combine two values from a field to a single value in the same field

vinieme12 — Tue, 01 Nov 2022 08:49:11 GMT

create a new field which groups values as below

Temp:

Load * Inline [

ComplianceType,Value

A,10

B,10

C,10

D,10

E,10

F,10

];

Grouping:

Load * inline [

ComplianceType,ComplianceGroup

A,A

B,B+C

C,B+C

D,D

E,E+F

F,E+F

];

Now use Dimension

=ComplianceGroup

Measure

=sum(Value)

Re: Need to combine two values from a field to a single value in the same field

abc_18 — Tue, 01 Nov 2022 10:10:31 GMT

Hi Vineeth,

Thanks for the response.

but have a question what to provide in value column in first inline load.

My compliance column contains values like (Compliance, Not compliance, overall and so on.....) and against these I am showing count of machines in bar chart (expression)

Re: Need to combine two values from a field to a single value in the same field

vinieme12 — Tue, 01 Nov 2022 10:27:11 GMT

whats important is the Grouping table

Just make sure to group your dimension values correctly and Use the ComplianceGroup field in your chart

Your measures will automatically aggregate based in the grouped values

Dimension:

ComplianceGroup

Measure

=Count(Something)

example

Grouping:

load * inline[

Compliance,ComplianceGroup

Compl,Compl

NonCompl,NonCompl

Compl,Compl+NonCompl

NonCompl,Compl+NonCompl

];

Re: Need to combine two values from a field to a single value in the same field

abc_18 — Tue, 01 Nov 2022 12:22:08 GMT

Hi Vineeth,

For single compliance value, numbers are populating correctly like for 'A' and 'D' but for values where I am doing addition (grouping) it's not working. My measures is automatically aggregating only for single values but for group values it's just coming as unassigned data like '-' and there can see the remaining count.

Re: Need to combine two values from a field to a single value in the same field

vinieme12 — Tue, 01 Nov 2022 12:36:28 GMT

Can you post some screenshots of Your data model that shows association with the Inline table created for grouping

Also post all values in your compliance field and your script as to how you've grouped them in the Inline table

If your grouped values are not associated correctly that would only mean the values don't match in both the tables

For example a value "a" is not same as "A"

Th values must match exactly including spaces

Re: Need to combine two values from a field to a single value in the same field

abc_18 — Tue, 01 Nov 2022 17:57:29 GMT

Hi Vineeth,

Yes, you are correct, there is data issue that's why the association isn't working.

I looked through the data model and saw that we are giving new names to the values we are adding up, as shown by the bolded text, so that the new names can be seen in the bar chart.

Below is the sample of Script from my app

Grouping:

load * inline[

Compliance,ComplianceGroup

NonCompl for XYZ,Not approved to have XYZ+Have latest version of XYZ
NonCompl for ABC,Machine to have data+Have latest version of ABC
Machine to have data , Machine to have data
Machine to have running , Machine to have running

];

And in Compliance column values are as below:

Compliance

Not approved to have XYZ

Have latest version of XYZ

Machine to have data

Have latest version of ABC

Machine to have running

For values 'Machine to have data' and 'Machine to have running' association are working because they are linked but this not in the case where we are adding values.

Can you please suggest what can I change to make this work?

Re: Need to combine two values from a field to a single value in the same field

vinieme12 — Wed, 02 Nov 2022 02:12:30 GMT

as below

Load * Inline [

Compliance,ComplianceGroup,ComplianceGroup_v2

Not approved to have XYZ,Not approved to have XYZ+Have latest version of XYZ,NonCompl for XYZ

Have latest version of XYZ,Not approved to have XYZ+Have latest version of XYZ,NonCompl for XYZ

Machine to have data,Machine to have data,Machine to have data

Machine to have data,Machine to have data+Have latest version of ABC,NonCompl for ABC

Have latest version of ABC,Machine to have data+Have latest version of ABC,NonCompl for ABC

Machine to have running,Machine to have running,Machine to have running

];

Re: Need to combine two values from a field to a single value in the same field

abc_18 — Wed, 02 Nov 2022 07:47:29 GMT

Have used the above concept and it's working as expected.

Thank you Vineeth for helping me fix this problem.