modifying name of the variables at the same time

[#1]

I am trying to pull in multiple tables but without connection.

but each table has variables with same names such as date, city, state and so on.

at the moment, I am changing the name of variables one by one for example table1_city, table1_state, table1_date and so on and table_2*****for second table.

is there any way to change names automatically?

Thank you!

[alexdataiq · Accepted solution]

If I understand right, maybe QUALIFY could help you.

Do you Qualify?- How to use QUALIFY statement

Regards.

[#3]

Thank you so much Eduardo,

I have one following question!

without meeting requirements to use QUALIFY

if I just want to modify name of the variables for the sake of recognizing from which table each variable came from

and just add the name of the table in front of each variable, is there a simple way to do that??

Thank you in advance for this too Eduardo!

[alexdataiq]

Hi David,

To be honest, I'm not sure if there's a simpler way of doing in than QUALIFY.

Any reason why QUALIFY doesn't work for what you want to achieve?

Regards.

[#5]

because it seems like qualify is used when there is at least one key that is joining the two tables.

but in my case, since I am using my dashboard to see the status of individual database, without trying to join any tables, it is not fit to use QUALIFY.

but I will be definitely using QUALIFY in the future. thank you so much!

[alexdataiq]

Oh I see. Well, you can use QUALIFY even if you don't want to join the tables. If you use QUALIFY * all your tables will have full qualified names and they will appear as individual unconnected tables.