Questions tagged [teradata-covalent]

Teradata Covalent is a UI platform built on Angular + Material Design

The Covalent UI platform is designed to be used on top of Angular & Angular Material. It includes components, services, and styles to simplify Angular development.

Features

  • Layout components
  • UI Components
  • Code/Markdown editors and parsers
  • Port of AngularJS Material flex layout directives
  • Utility CSS styles
  • QuickStart example app

Useful Links

39 questions
1
vote
1 answer

Supplied parameters do not match any signature of call target on api call angular4

I am consuming an api to Covalent UI, on user service. Which needs to post some data from an endpoint to the table as illustrated on the example from the GitHub. Here is the modification I have made to the service. import { Provider, SkipSelf,…
G B
  • 2,323
  • 3
  • 18
  • 32
1
vote
0 answers

Angular 4.0 Teradata data-table ng-template for all columns

does anybody know if there is a way to apply an < ng-template > for all columns in the < td-data-table > by declaring only one < ng-template > and not one for every column. Something like:
Leonzen
  • 1,195
  • 5
  • 13
  • 30
1
vote
1 answer

Fetching data from a service using Data Table(TeraData Covalent)

I am trying to fetch data from a service and show them in a datatable using Covalent , the only issue I seem not to figure out how to go about it. Initially Was using twitter bootstrap with datable and it was working fine. I was chug to material…
G B
  • 2,323
  • 3
  • 18
  • 32
1
vote
1 answer

Open dialogue from edit action button in Teradata Covalent data-table

I am using TeraData Covalent's datatable in my angular project. The template I used had the following options for action buttons. actionButtons: any[] = [ { 'title': "View", 'icon': "visibility", 'url':…
Ali Turab Abbasi
  • 1,103
  • 8
  • 22
0
votes
0 answers

Teradata normalize equivalent in Snowflake

I'm working on convertion of sql from Teradata to snowflake, I've encoutered Normalize in sql with period(). Is there any equivalent in snowflake? ... select normalize id, abc, xyz, period(time, case when mtnt = mtnt_bb_l and net_bb =…
0
votes
0 answers

I am unable to find some of the features in covalent/core version 4 for Angular 12 which are found in version 3

I am using covalent/core version 4 in my Angular 12 project and unable to find the covalent/core/loading, covalent/core/media and few more libraries which are available in the covalent/core version 3 or below. The problem is the version 3 doesn't…
0
votes
1 answer

How do I Select all duplicates

I am trying to develop a DMR from the DMR #1 which return all the data which are identified by DMR #1 so that I can load them to a work table and then delete the duplicates before inserting back to the main table. So I have DMR #2 but when execute…
0
votes
1 answer

How to decare a variable in Teradata sql and call them in a select statement?

I want to declare two variable and use thoes variable in where condition of a select statement in teradata, but I am getting an error in that. Create Procedure Demo() Begin Declare REnd Date; Declare RStart Date; Set REnd = (select…
0
votes
0 answers

Query to determine column values shorter than normal

I have a column whose values are supposed to be 11 numbers, however, some of them have less than 11 numbers. How can I write a query that will return all the values in this column that have less than 11 numbers. I am working in Teradata
0
votes
0 answers

3706 syntax error in teradata expected something between ')' and the 'AS' keyword

I am getting the error message "3706 syntax error in teradata expected something between ')' and the 'AS' keyword" when try to run an update query in Teradata. There are red dotted lines on ") AS PRSCRBR_LAST_NM," on the second line of the query…
0
votes
0 answers

Expecting something between ')' and the 'AS' keyword

I am trying to run the update query below in Teradata but getting an error message 'Expecting something between ')' and the 'AS' keyword. I am missing anything? I have checked some previous update and it worked for other developers in my company. …
0
votes
2 answers

How can I get only the data that do not match

I have the query below, TBL1 X is my source table and TBL2 Y is my target table. I want to get only the data from TBL1 X that any of the fields indicated below don't match their corresponding fields in TBL2 Y. I am not a 100% sure that the code is…
0
votes
1 answer

How do I compare two columns from two different tables

I am running a CREATE TABLE TBL AS SELECT statement as below. I want to write a CASE STATEMENT that will compare values from column X.PRESC_ID to values from column Y.PRSC_NPI and if there is match, it should INSERT to TBL.PRESC_ID, and for all…
0
votes
0 answers

Wrong number of data values in record

I have some tab delimited files that I am importing from a folder using SQL Assistant. These files each have more than 200 thousand records, when I try to insert them, I get the error message 'Wrong number of data values in record', I have tried…
Bond
  • 25
  • 2
  • 13
0
votes
2 answers

Can we install teradata express on GCP compute instance?

I'm trying to work out a way to install teradata express on GCP compute instance or any other GCP compute service?? any leads would be appreciated.. thank you..!!