Update table with new values using SAS Data Integration Studio

[ashna]

Hi Everyone,

I have a Table1 with 3items with some charges

Table1:
Name           Amount

Item 1            $500
Item 2            $260
Item 3            $800

When I get input file with Table 2 I need compare the values betrween Table 1 and Table 2 and if there any changes in Amount I need to update Table 1 with change.

Table2:
Name           Amount

Item 1            $500
Item 2            $260
Item 3            $100

When I compare Table1 with Table 2 there is difference in amount for Item3. 

So I have to update Table1 as follows: (instead of $800 in amount for Item3 I need to write $100)

Table1:
Name           Amount

Item 1            $500
Item 2            $260
Item 3            $100

How can I do it using SAS Data Integration Studio?

[JBailey]

Hi @ashna

The Table Loader Transformation will do this.

Check out: http://support.sas.com/documentation/cdl/en/etlug/67323/HTML/default/viewer.htm#n12xc125b6bgi2n1y22h...

Best wishes,

Jeff

[ashna · Accepted solution]

Used Modify function. That worked well. Thanks everyone