1 Reply Latest reply on Jun 6, 2016 9:25 AM by Derrick Austin

Reverse the 2 columns during the UNION ALL?

Kevin MONGES Jun 6, 2016 9:22 AM

Hi,

I would like to reverse some column during the UNION ALL in the Custom SQL.

I work with a mysql database.

I tried to change the alias and it seems that it doesn't work.... Is there a way to do what I try to do ?

For example I would like to reverse :

Thank you very much

Kevin

1. Re: Reverse the 2 columns during the UNION ALL?

Derrick Austin Jun 6, 2016 9:25 AM (in response to Kevin MONGES)

Hey Kevin,

The order of the fields in the UNION is dependant on the ordering in the query.
If I'm understanding correctly, you just need something like this:

SELECT ID, NOM, PRENOM
FROM tableA

UNION ALL

SELECT ID, PRENOM, NOM
FROM tableB
1 of 1 people found this helpful
Like Show 3 Likes(3)

Actions

Tableau Community Forums