Patch one table on top of another

(0) Share

Report

Posted on by SmoothOperator

Tried my best to find a title, but not sure how to post it exactly... So...

I have a table 1

Name	ID
John	1
George	2
Jim	3
Bill	4

and I have another table 2

Name	ID
Chris	1
Patric	2
Francois	3

I want to always keep the second table, and put on the beginning of the second table the first one and adjust the ID accordingly.

Preferably I would like to do that with collections..

The result I want is :

John	1
George	2
Jim	3
Bill	4
Chris	5
Patric	6
Francois	7

Hope you understood the needed result!

Thank you in advance 🙂

Categories:

General Questions

Using Apps Using Formulas

All responses (6)

Answers (1)

eka24 20,921 on at

Like (0)

Report

Re: Patch one table on top of another

That is fine.

Thanks

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
SmoothOperator 48 on at

Like (0)

Report

Re: Patch one table on top of another

I did this but with a ShowColumns() way and managed to make them both the same column collections and then used the intitial way you proposed

Thank you!
Verified answer

eka24 20,921 on at

Like (0)

Report

Re: Patch one table on top of another

Try this:

ClearCollect(JoinedTable,Table1,RenameColumns(Table2,"Name2","Name","ID2","ID"));

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
eka24 20,921 on at

Like (0)

Report

Re: Patch one table on top of another

Your table had same columns. Did it work?

If different column names we can use AddColumns

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
SmoothOperator 48 on at

Like (0)

Report
Re: Patch one table on top of another

if both tables have different columns though? I believe that
ClearCollect( JoinedTable, Table1,Table2 )
does not work and merges them. They should be exactly the same..
any thoughts?
eka24 20,921 on at

Like (0)

Report

Re: Patch one table on top of another

@SmoothOperator

ClearCollect(JoinedTable,Table1,Table2)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.