Skip to main content
S
saikrishnam0001
February 17, 2022
Question

can any one please help me how we can upload comma seperated file in ?expression n interface label formattiing data

  • February 17, 2022
  • 8 replies
  • 0 views

can any one please help me how we can upload comma seperated file in CSV format then after we want to achieve the excel file as seperated in the below format

ItemCode Company Name  Supported Companies
MR, CR Amazon DMART, RELIANCE
MR, CR Amazon DMART, RELIANCE
The above Cells want to get in the below format 
→ ItemCode Company Name  Supported Companies
MR Amazon DMART
CR Amazon  RELIANCE

    8 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 17, 2022

    I do not understand your question. Please elaborate.

    docs.appian.com/.../File_Upload_Component.html

    S
    saikrishnam0001Author
    February 18, 2022

    Please help me how we can upload comma seperated file in CSV format then after we want to achieve the excel file as seperated in the below format

    ItemCode Company Name  Supported Companies
    MR, CR Amazon DMART, RELIANCE
    MR, CR Amazon DMART, RELIANCE
    The above Cells want to get in the below format 
    → ItemCode Company Name  Supported Companies
    MR Amazon DMART
    CR Amazon  RELIANCE
    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 18, 2022

    In general, Appian is no high volume data transformation tool.

    That said, the most efficient way of doing this kind of things, is by loading the CSV into DB and execute a stored procedure for transformation.

    What did you try so far? What failed? What concrete issues do you have?

    Terms & ConditionsAccessibility statement