ai-knowledge-assistant Sequential question

The bot is not able to somehow interact with Appian, as of now. This is a first version and Appian will enhance the features with newer versions.

Hi Stefan Helzle 

Sentence: "database table for banking application with data type and description in appian grid format" 

| Column Name | Data Type | Description | | --- | --- | --- | | account_id | Integer | Unique identifier for an account | | account_type | Text | Type of account (e.g. savings, checking, credit, etc.) | | balance | Decimal | Current balance of the account | | last_transaction_date | Date | Date of last transaction made on the account | | owner_name | Text | Full name of the account owner | | owner_email | Text | Email address of the account owner | | owner_phone | Text | Phone number of the account owner | | address | Text | Mailing address of the account owner | | city | Text | City of residence of the account owner | | state | Text | State of residence of the account owner | | zip_code | Text | Zip code of the account owner's residence | | transaction_type | Text | Type of transaction (e.g. deposit, withdrawal, transfer) | | transaction_amount | Decimal | Amount of the transaction | | transaction_date | Date | Date of the transaction | | transaction_description | Text | Description or purpose of the transaction | | transaction_status | Text | Status of the transaction (e.g. pending, completed, cancelled) | | beneficiary_name | Text | Full"

I want to convert this data into a editable grid. Suggestions are most welcome.

Where do you getting this data from??

 Is it related to AI Skills???

whatever the data your are getting saleem, split it based on "| " symbol using split function

and using for each function get the plitted data and pass it as a expression or local variable it will resolve your issue

Please check below 

whatever the data your are getting saleem, split it based on "| " symbol using split function

and using for each function get the plitted data and pass it as a expression or local variable it will resolve your issue

a!localVariables(
local!text: "| Column Name | Data Type | Description | | ---- | ----- | --- | | account_id | Integer | Unique identifier for an account | | account_type | Text | Type of account (e.g. savings, checking, credit, etc.) | | balance | Decimal | Current balance of the account | | last_transaction_date | Date | Date of last transaction made on the account | | owner_name | Text | Full name of the account owner | | owner_email | Text | Email address of the account owner | | owner_phone | Text | Phone number of the account owner | | address | Text | Mailing address of the account owner | | city | Text | City of residence of the account owner | | state | Text | State of residence of the account owner | | zip_code | Text | Zip code of the account owner's residence | | transaction_type | Text | Type of transaction (e.g. deposit, withdrawal, transfer) | | transaction_amount | Decimal | Amount of the transaction | | transaction_date | Date | Date of the transaction | | transaction_description | Text | Description or purpose of the transaction | | transaction_status | Text | Status of the transaction (e.g. pending, completed, cancelled) | | beneficiary_name | Text | Full",
local!forEach1: a!forEach(
items: split(local!text, "|"),
expression: {
if(
or(
a!isNullOrEmpty(fv!item),
find("---", fv!item) > 0,
),
{},
fv!item
)
}
),
local!union: union(local!forEach1, local!forEach1),
local!union
)

Yes  

This is working as expected. Thank you manishs0028 

As your question has nothing to do with the initial topic, I suggest to start a new conversation!

As your question has nothing to do with the initial topic, I suggest to start a new conversation!