Hi All,
I have been trying to remove hidden \r\n from the input string and want output as shown below.
Do begin
declare str_split varchar(1000) := '60.0,6000.0
60.0,6,6004.9
';
declare rep_str varchar(1000);
select replace(:str_spl...
Hi All,
I created simple flow-graphs(Web IDE HDI container XSA) using synonym of virtual table from different schema as source and template as target table. I included projection node in between and enable data preview using debug mode(data previe...
Hi All,
I am stuck in below scenario.
For example, there is a test let’s call it ‘Current Calibration Data' is conducted on some product with some parameters like setpoint, readback, v_offset. Once the product is being tested it will generate th...
Hi All,
I have created a table with an 'ID' column and it automatically creates a sequence name "_SYS_SEQUENCE_4231595_#0_#"'.
I know if you delete and reload the data from the table, the sequence won't reset. I am trying to reset the sequence ...
Hi Community Members,
I have a requirement where I need to extract data from the text file and load it into the HANA tables. The text file is contained data as shown in the attached file.
Highlighted one show fields and corresponding data for e...
Hi Michael, Thank you for your response. I am glad you asked questions out of your curiosity. This is my current client assignment on which I am working. I am getting the flat-files (txt format). Also, data is not in structure format in these files b...
Hey, I have the same requirement as shown below. How to convert these data rows to columns. If you found the resolution, would you please share it?Thank YouSunil Sharma
