kumar25
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
Transpose columns(Dynamic) into rows.
Hi, I have to convert/transpose columns into rows. Basis the input file the count of columns may increase/decrease. Have to pick all the columns and convert them into rows. Input: INV111 INV112 INV113 INV114 INV115 INV116 INV117 INV118 TFR089 TFR2 TFR3 TFR34 TFR53 TFR67 TFR222 TFR902 TDR1 TDR087 TDR22 TDR44 TDR575 TDR58 TDR96 TDR67 TFET9 TFET7 TFET4 TFET22 TFET87 TFET34 TFET099 TFET123 VER0 VER1 VER2 VER3 VER4 VER5 VER6 VER7 USD USD USD USD USD USD USD USD FY24 FY24 FY24 FY24 FY24 FY24 FY24 FY24 Jan Feb Mar Apr May Jun Jul Aug 4,206.21 46,557.34 5,701.96 5,775.38 18,677.77 6,046.35 4,733.21 4,764.49 Output: INV111 TFR089 TDR1 TFET9 VER0 USD FY24 Jan 4,206.21 INV112 TFR2 TDR087 TFET7 VER1 USD FY24 Feb 46,557.34 INV113 TFR3 TDR22 TFET4 VER2 USD FY24 Mar 5,701.96 INV114 TFR34 TDR44 TFET22 VER3 USD FY24 Apr 5,775.38 INV115 TFR53 TDR575 TFET87 VER4 USD FY24 May 18,677.77 INV116 TFR67 TDR58 TFET34 VER5 USD FY24 Jun 6,046.35 INV117 TFR222 TDR96 TFET099 VER6 USD FY24 Jul 4,733.21 INV118 TFR902 TDR67 TFET123 VER7 USD FY24 Aug 4,764.49Solved1.9KViews0likes5CommentsRe: How to read .xlsb file
Hi koryknick this was a file created on Windows machine. Wanted to see if there is any possibility to use any script to convert the file to a readable file(.xlsx/.xlsm). I have to check on the possibility to open a support team, not sure if I have access.909Views0likes0CommentsNot able to map output of PostgreSQL - Execute
Hi, I am executing a query using PostgreSQL - Execute, and getting the below output. I am not able to map it in mapper. [ { "item_id": { "UUID": "024b0ca1-96ae-4c9c-be26-21990a46e684" }, "active": true, "title": "NEW", "description": null, "file_id": null, "file_date": null, "file_extension": null, "file_name": null, "file_size": null, "assignee_person_item_id": null, "audit_id": { "UUID": "cb986ed0-0edd-4579-abcd-62f3ba1be9b3" }, "list_id": { "UUID": "62847ae0-ce9f-44bf-96ce-0a5275474008" }, "added_on": { "_snaptype_localdatetime": "2022-03-02T12:30:27.105" }, "last_updated_on": { "_snaptype_localdatetime": "2022-03-08T20:06:53.992" } } ]463Views1like1Comment