Add field from different table

[varma8998]

Hi All,

I have two tables In the data manager

I need the solution I want to add the field from another table

Example:

Table1:

X          Y             Z

1           AAA        123

2           BBB         456

3           CCC        789

4          DDD         101

Table2:

A    B     C

X    Y      Z

I need the output in the below format

Output:

X    Y          Z      C

1    AAA    123     Z

2   BBB     456     Z

3   CCC    789     Z

4   DDD    101     Z

[sunny_talwar]

Table2 only have a single value and you want that value to be associated with all the values from Table1? Try this

Table:
LOAD X, Y, Z
FROM Table1;

Join (Table)
LOAD C
FROM Table2;

[varma8998]

Hi Sunny,

Thanks for quick response

C is the calculated filed in the table 2 that's the reason I am getting error that filed is not found

[sunny_talwar]

Would you elaborate this with a better example

[varma8998]

Hi Sunny,

I will try to explain everything step by step clearly

I have 2 Tables

Table 1 is direct one

Table 2 we have to calculate few things in the sheet

example table will be in the below format

X     Y          Z

1     B      03/31/2019

2     C       XYZ

3     D       YZA

Here I want to add the new filed quarter

with this formula  'Q' & Ceil(Month(date)/3) I have created New Filed quarter

Than I got the output

X     Y          Z                Quarter

1     B      03/31/2019    Q1

2     C       XYZ               Q

3     D       YZA                Q

after that I want to delete all the rows what ever it is not required.

by using Where Clause I deleted the rows than I got the output

X     Y          Z                Quarter

1     B      03/31/2019    Q1

Created field quarter I want to add in the table 1

[sunny_talwar]

Okay, I don't see why you can't do a join after you have calculated the value and used your where clause?

[varma8998]

Hi Sunny

Every time quarter will change right if we do where clause after join than it will be a problem I guess

[sunny_talwar]

after join? I have no idea what you mean... sorry, but may be someone else can offer help here 🙂