4 Replies Latest reply: Jan 13, 2016 4:14 PM by Paras Doshi RSS

    Hi Friends I have below Sample Dataset I want to give the column names of one table by another table values brief Example  is below added. Please suggest me what will be the Query?

    Bibhuti Sahoo

      [SalesHeader]:

      LOAD [col1],

        [col2],

        [col3]

      FROM [lib://Desktop/x2.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      below is Data

       

      col1col2col3
      Sales ValueSales QtyNet Sales

       

       

      [SalesData]:

      LOAD [A],

        [B],

        [C]

      FROM [lib://Desktop/x1.xlsx]

      (ooxml, no labels, table is Sheet1);

       

      Sample Data without header now.

       

      1234380
      1244282
      1254184
      1264086

       

       

      I want to give the header such as col1 header will be SalesHeader table first column i.e col1 value like that all.

       

      Sales Value Sales Qty Net Sales

      1234380
      1244282
      1254184
      1264086

       

       

      Is it possible friends?? please suggest me. Thanks,

      Bibhuti