Joins in Quicksight

[Vysh27]

Hi Community
I have 2 different excel files with the same columns but the metrics column in both excel have different values.
Now in quicksight how do I append the metrics column into one so that all the values come under one column

[ErikG]

Hi @Vysh27
Are there entries with two values?
BR

[Vysh27]

Yes @ErikG
let me give an example
As you can see in the below image
there are 2 field metrgap analysis and metrics
I want to append both the field to one
is it possible?
n

[ErikG]

Hi @Vysh27
By “append” you mean merge or you only want to have one value?
For your sample what would be the expected outcome?
BR

[Vysh27]

The outcome that I want would be
i.e Amazon only
Amazon and ICs
Amazon and Gap Analysis

They should be appended like this

[neelay]

@Vysh27
Can’t see the image you attached,
But if i understood correctly you can try concat with if-else or switch?

something like this for custom field

ifelse(
    (metrgap != '' AND metrics != '' ), concat({metrics},{metrgap}), 
    ifelse((metrics != '' AND  metrgap = ''), concat({metrics},' only'), 
    ifelse((metrics == '' AND  metrgap != ''), concat({metrgap},' only'), 'N/A')
  )
)

[Vysh27]

I want to get something like this
I have joined two tables
but now I have to append them
how do I do it

[Koushik_Muthanna]

I think the simplest is to combine using excel itself (Re: Combine Multiple Excel Sheets with Different Columns - Microsoft Community Hub ) and bring the final data to QuickSight.

Else you could do a full join ( I am assuming on column A )

Create a calculated field

A_main = coalesce({A},{A[qw]})

Exclude fields you then don’t need .
Save and Publish the dataset.