Hi,
Can any one please help me with the query currently iam using " | rename * AS \|*\| " but i don't want \ in the header so i want like |PeriodDate| only.
\|PeriodDate\| | \|VendorName\| | \|ContractName\| | \|Code\| |
|2021/12/19| | |SAM| | |HI-HI| | |511| |
|2021/12/19| | |SAM| | |HI-HI| | |51.1| |
|2021/12/19| | |SAM| | |HI-HI| | |51.1| |
looks it worked with | rename * AS "|*|"