Append rows from 2 tables into a new table based on Matching column value

Hey prabhatnath ,

I think I got your question.

You can first do an inner of the second table with the first, then only the IDs will be left that exist in the first table.

Afterwards you can do an append.

Please see the attached file for details.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic