0 Replies Latest reply: Mar 26, 2013 6:10 PM by Anup Singh RSS

    Link table

      i am using below script to create link table

      SET ThousandSep=',';

      SET DecimalSep='.';

      SET MoneyThousandSep=',';

      SET MoneyDecimalSep='.';

      SET MoneyFormat='$#,##0.00;($#,##0.00)';

      SET TimeFormat='h:mm:ss TT';

      SET DateFormat='M/D/YYYY';

      SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

      SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

      T1:

      LOAD id,

           name,

           id&'/'&name as key,

           add,

           sal

      FROM

      C:\Users\user\Desktop\Ex.xlsx

      (ooxml, embedded labels, table is Sheet1);

      T2:

      LOAD id,

           name,

           id&'/'&name as key,

           dep,

           loc

      FROM

      C:\Users\user\Desktop\Ex.xlsx

      (ooxml, embedded labels, table is Sheet2);

      T3:

      LOAD id,

           gis,

           tag

      FROM

      C:\Users\user\Desktop\Ex.xlsx

      (ooxml, embedded labels, table is Sheet3);

       

      linktable:

      load Distinct

      id,

           name,

           id&'/'&name as key,

           add,

           sal Resident T1;

           Concatenate

         load Distinct 

           id,

           name,

           id&'/'&name as key,

           dep,

           loc Resident T2;

           Concatenate

           load distinct

           id,

           gis,

           tag

           Resident T3;

          

           drop Fields

           id,

           name

           from T1,T2,T3;

       

       

      but not able to create pls provide the correct script.