topic Re: Combine 2 datasets into 1 in Connectivity & Data Prep

Combine 2 datasets into 1

CarolinedeVos — Mon, 31 Oct 2022 15:32:37 GMT

Hi,

I created an app via the REST connector with GET method. But the output I get is splitted into 2 datasets. One dataset with headers and one dataset with the corresponding data. Why is this devided and how can I combine the two in one dataset?

Re: Combine 2 datasets into 1

RafaelBarrios — Mon, 31 Oct 2022 22:21:11 GMT

hi @CarolinedeVos

It's hard to say without knowing what each of the datasets contains and how they are related.

but in general, if you can connect them by a common field, just rename it so that the field is called the same in both tables and you will have it.

the other option would be to do a join (inner, outer, left or right) everything will depend on what you have and what the result should be

Let's say you already load your tables Table1 and Table2 and the field you want to connect to in Table1 is called Id and in table2 it's called Client_id

what you will have to do is to rename the field when you make the REST call or to reload the table with a resident call to rename the field and delete the old table.

Table3:
Load
Client_id as Id,
field1,
field2,
.......
Resident Table2;

Drop table Table2;

hope this works for you.

Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂

Re: Combine 2 datasets into 1

CarolinedeVos — Thu, 03 Nov 2022 09:49:53 GMT

Hi Rafael,

Thanks for your reply. Unfortunately their are no identical fields. In one table the headers of the data are shown. In the other table the values of the data are shown. I have added two screenshots of the tables I use. What I want to create is one table with the headers as column names and the values in the underlying rows.

Hopefully this makes it clearer for you and you know a solution for it 🙂

Kind regards.