topic Re: Merge two values as one (value bot field)in load script ? in App Development

Merge two values as one (value bot field)in load script ?

Daryn — Wed, 15 Jun 2022 09:46:09 GMT

Good day everyone,

Thanks as always for your time/knowledge and help in advance.

I have a field [Company] this contains various values, of which two of them 'FR01' and 'FR02' I would like to merge/combine these two as one, ie: FR03. Or FR01 could just contain both.

But not as a new field, just as a new value within that [Company] field?

If([Company]= 'FR01','FR02') AS FR03,

Simply creates a field FR03.

Can this be done? I assumed I was better to do this in load script than every time it appears within a chart or sheet.

Thanks as always,

Regards Daryn

Re: Merge two values as one (value bot field)in load script ?

Or — Wed, 15 Jun 2022 09:51:36 GMT

Load If([Company]= 'FR02','FR01',[Company]) AS Company

From YourTable;

Re: Merge two values as one (value bot field)in load script ?

Daryn — Wed, 15 Jun 2022 11:23:24 GMT

Hi Or,

Many thanks for your reply.

This still seems to load as a separate field rather than value within the [Company] field?

Below image: Expression editor - fields

Below image: (no new FR03) value in above showing values of [Company]

Apologies if I have misunderstood or not explained my requirement fully.

Regards, Daryn

Re: Merge two values as one (value bot field)in load script ?

Or — Wed, 15 Jun 2022 12:22:07 GMT

As I wrote it, the FR02 rows should be merged into FR01, as you described in the original post.

The FR03 field is not part of my suggestion, and is presumably related to something else you've done.

Re: Merge two values as one (value bot field)in load script ?

Daryn — Wed, 15 Jun 2022 12:25:13 GMT

Apologies Or, my misunderstanding and you are correct of course and it works 👍

Thank you again, much appreciated.